CSV File Structures (Stock Records)
|
Field |
Type |
Size |
Validation |
Precision |
Import Type |
|
Product Code |
Char |
30 |
Yes |
|
Standard / Extended |
|
Description |
Char |
60 |
|
|
Standard / Extended |
|
Tax Code |
Int |
2 |
T0 û T99 |
|
Standard / Extended |
|
Sales Price |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
|
Unit of Sale |
Char |
8 |
|
|
Standard / Extended |
|
Location |
Char |
16 |
|
|
Standard / Extended |
|
Nominal Code |
Char |
8 |
Lookup |
|
Standard / Extended |
|
Stock Category Number |
Int |
3 |
1 - 999 |
3 digits + 0 d.p. |
Standard / Extended |
|
Department No |
Int |
3 |
1 - 999 |
3 digits + 0 d.p. |
Standard / Extended |
|
Supplier Account Ref |
Char |
8 |
Lookup |
|
Standard / Extended |
|
Part Number |
Char |
16 |
|
|
Standard / Extended |
|
Re-order Level |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
|
Item Type |
Int |
2 |
0, 1 or 2 |
|
Extended |
|
Commodity Code |
Char |
30 |
|
|
Extended |
|
Weight |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
|
Stock Take Date |
Date |
10 |
Date |
|
Extended |
|
Quantity In Stock |
--- |
--- |
|
|
Not Included |
|
Quantity Allocated |
--- |
--- |
|
|
Not Included |
|
Free Stock |
--- |
--- |
|
|
Not Included |
|
Quantity On Order |
--- |
--- |
|
|
Not Included |
|
Last Order Quantity |
--- |
--- |
|
|
Not Included |
|
Last Order Date |
--- |
--- |
|
|
Not Included |
|
Re-order Quantity |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
|
Cost Price |
--- |
--- |
|
|
Not Included |
|
Stock Take Quantity |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
|
Memo |
--- |
--- |
|
|
Not Included |
|
Component No 1-10, Stock Code |
--- |
--- |
|
|
Not Included |
|
Component No 1-10, Quantity |
--- |
--- |
|
|
Not Included |
|
Sales Value û Sales Cost Bfwd, Months 1-12, Future |
--- |
--- |
|
|
Not Included |
|
Sales Value û Actuals Bfwd, Months 1-12, Future |
--- |
--- |
|
|
Not Included |
|
Sales Value û Budgets Bfwd, Months 1-12, Future |
--- |
--- |
|
|
Not Included |
|
Sales Value û Prior Year Bfwd, Months 1-12, Future |
--- |
--- |
|
|
Not Included |
|
Qty Sold û Actuals Bfwd, Months 1-12, Future |
--- |
--- |
|
|
Not Included |
|
Qty Sold û Budgets Bfwd, Months 1-12, Future |
--- |
--- |
|
|
Not Included |
|
Qty Sold û Prior Year Bfwd, Months 1-12, Future |
--- |
--- |
|
|
Not Included |
|
Discount Table A - E,
Level 1-10, |
--- |
--- |
|
|
Not Included |
|
Discount Table A - E,
Level 1-10, |
--- |
--- |
|
|
Not Included |
|
Image |
--- |
--- |
|
|
Not Included |
Related Topics